Overview
Brought to you by YData
Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 163920 |
| Missing cells | 15283 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 219.1 MiB |
| Average record size in memory | 1.4 KiB |
Variable types
| Text | 5 |
|---|---|
| Categorical | 11 |
| Numeric | 13 |
| DateTime | 2 |
AccidentYear has constant value "2018" | Constant |
HeadofDamage has constant value "AD" | Constant |
CumGrossEstimate is highly overall correlated with CumGrossIncurred and 4 other fields | High correlation |
CumGrossIncurred is highly overall correlated with CumGrossEstimate and 3 other fields | High correlation |
CumGrossPaid is highly overall correlated with CumGrossIncurred and 3 other fields | High correlation |
CumPaid is highly overall correlated with CumGrossPaid and 2 other fields | High correlation |
CumRecovered is highly overall correlated with RecoveredDelta | High correlation |
CumReserved is highly overall correlated with CumGrossEstimate and 4 other fields | High correlation |
FaultIndicator is highly overall correlated with IncidentCause | High correlation |
GrossEstimateDelta is highly overall correlated with CumGrossEstimate and 3 other fields | High correlation |
GrossIncurredDelta is highly overall correlated with CumGrossEstimate and 4 other fields | High correlation |
GrossPaidDelta is highly overall correlated with CumGrossPaid and 2 other fields | High correlation |
IncidentCause is highly overall correlated with FaultIndicator | High correlation |
PaidDelta is highly overall correlated with CumGrossPaid and 2 other fields | High correlation |
RecoveredDelta is highly overall correlated with CumRecovered | High correlation |
ReservedDelta is highly overall correlated with CumGrossEstimate and 3 other fields | High correlation |
UWClass is highly overall correlated with UWProduct and 1 other fields | High correlation |
UWProduct is highly overall correlated with UWClass | High correlation |
VehicleType is highly overall correlated with UWClass | High correlation |
ClaimStatus is highly imbalanced (96.5%) | Imbalance |
VehicleType has 2490 (1.5%) missing values | Missing |
ClaimNarrative has 12475 (7.6%) missing values | Missing |
CumPaid is highly skewed (γ1 = 25.81692868) | Skewed |
CumRecovered is highly skewed (γ1 = -31.77516515) | Skewed |
CumReserved is highly skewed (γ1 = 27.51828117) | Skewed |
CumGrossPaid is highly skewed (γ1 = 22.24961469) | Skewed |
CumGrossEstimate is highly skewed (γ1 = 27.51828117) | Skewed |
PaidDelta is highly skewed (γ1 = 32.18337485) | Skewed |
RecoveredDelta is highly skewed (γ1 = -28.0644639) | Skewed |
GrossPaidDelta is highly skewed (γ1 = 25.81912121) | Skewed |
CumPaid has 95393 (58.2%) zeros | Zeros |
CumRecovered has 147023 (89.7%) zeros | Zeros |
CumReserved has 114107 (69.6%) zeros | Zeros |
CumGrossPaid has 84792 (51.7%) zeros | Zeros |
CumGrossEstimate has 114107 (69.6%) zeros | Zeros |
CumGrossIncurred has 38080 (23.2%) zeros | Zeros |
PaidDelta has 104246 (63.6%) zeros | Zeros |
RecoveredDelta has 147663 (90.1%) zeros | Zeros |
ReservedDelta has 75761 (46.2%) zeros | Zeros |
GrossPaidDelta has 88892 (54.2%) zeros | Zeros |
GrossEstimateDelta has 75761 (46.2%) zeros | Zeros |
GrossIncurredDelta has 41133 (25.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-04 17:25:46.202606 |
|---|---|
| Analysis finished | 2025-07-04 17:27:09.782131 |
| Duration | 1 minute and 23.58 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
| Distinct | 46860 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.5 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 18513 ? |
|---|---|
| Unique (%) | 11.3% |
Sample
| 1st row | REF_427705 |
|---|---|
| 2nd row | REF_427705 |
| 3rd row | REF_547892 |
| 4th row | REF_547892 |
| 5th row | REF_547892 |
| Value | Count | Frequency (%) |
| ref_103655 | 34 | < 0.1% |
| ref_800001 | 33 | < 0.1% |
| ref_186272 | 32 | < 0.1% |
| ref_359085 | 31 | < 0.1% |
| ref_973920 | 30 | < 0.1% |
| ref_909642 | 30 | < 0.1% |
| ref_505528 | 29 | < 0.1% |
| ref_775194 | 29 | < 0.1% |
| ref_830953 | 29 | < 0.1% |
| ref_241006 | 29 | < 0.1% |
| Other values (46850) | 163614 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 0 | 99630 | 6.1% |
| 3 | 99590 | 6.1% |
| 2 | 98750 | 6.0% |
| 1 | 98749 | 6.0% |
| 4 | 98515 | 6.0% |
| 6 | 98460 | 6.0% |
| Other values (4) | 389826 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 0 | 99630 | 6.1% |
| 3 | 99590 | 6.1% |
| 2 | 98750 | 6.0% |
| 1 | 98749 | 6.0% |
| 4 | 98515 | 6.0% |
| 6 | 98460 | 6.0% |
| Other values (4) | 389826 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 0 | 99630 | 6.1% |
| 3 | 99590 | 6.1% |
| 2 | 98750 | 6.0% |
| 1 | 98749 | 6.0% |
| 4 | 98515 | 6.0% |
| 6 | 98460 | 6.0% |
| Other values (4) | 389826 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 0 | 99630 | 6.1% |
| 3 | 99590 | 6.1% |
| 2 | 98750 | 6.0% |
| 1 | 98749 | 6.0% |
| 4 | 98515 | 6.0% |
| 6 | 98460 | 6.0% |
| Other values (4) | 389826 |
AccidentYear
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2018 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2018 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2018 |
| 4th row | 2018 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 163920 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2018 | 163920 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 163920 | |
| 0 | 163920 | |
| 1 | 163920 | |
| 8 | 163920 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 655680 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 163920 | |
| 0 | 163920 | |
| 1 | 163920 | |
| 8 | 163920 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 655680 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 163920 | |
| 0 | 163920 | |
| 1 | 163920 | |
| 8 | 163920 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 655680 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 163920 | |
| 0 | 163920 | |
| 1 | 163920 | |
| 8 | 163920 |
DevelopmentMonth
Real number (ℝ)
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.6592362 |
| Minimum | 1 |
|---|---|
| Maximum | 91 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 9 |
| Q3 | 12 |
| 95-th percentile | 21 |
| Maximum | 91 |
| Range | 90 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 7.296256 |
|---|---|
| Coefficient of variation (CV) | 0.75536573 |
| Kurtosis | 22.305352 |
| Mean | 9.6592362 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 3.5178559 |
| Sum | 1583342 |
| Variance | 53.235352 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 13530 | 8.3% |
| 8 | 13175 | 8.0% |
| 7 | 12557 | 7.7% |
| 6 | 12074 | 7.4% |
| 10 | 12059 | 7.4% |
| 5 | 11314 | 6.9% |
| 9 | 11079 | 6.8% |
| 4 | 10147 | 6.2% |
| 12 | 10055 | 6.1% |
| 3 | 9756 | 6.0% |
| Other values (81) | 48174 |
| Value | Count | Frequency (%) |
| 1 | 4263 | 2.6% |
| 2 | 7917 | |
| 3 | 9756 | |
| 4 | 10147 | |
| 5 | 11314 | |
| 6 | 12074 | |
| 7 | 12557 | |
| 8 | 13175 | |
| 9 | 11079 | |
| 10 | 12059 |
| Value | Count | Frequency (%) |
| 91 | 2 | < 0.1% |
| 90 | 3 | < 0.1% |
| 89 | 3 | < 0.1% |
| 88 | 2 | < 0.1% |
| 87 | 10 | |
| 86 | 12 | |
| 85 | 7 | |
| 84 | 14 | |
| 83 | 17 | |
| 82 | 17 |
HeadofDamage
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.2 MiB |
| AD |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AD |
|---|---|
| 2nd row | AD |
| 3rd row | AD |
| 4th row | AD |
| 5th row | AD |
Common Values
| Value | Count | Frequency (%) |
| AD | 163920 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ad | 163920 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 163920 | |
| D | 163920 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 327840 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 163920 | |
| D | 163920 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 327840 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 163920 | |
| D | 163920 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 327840 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 163920 | |
| D | 163920 |
SubHeadOfDamage
Categorical
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.6 MiB |
| All PH Repair Costs (Exc Fees) | |
|---|---|
| Windscreen Replacement | |
| Miscellaneous Recovery | |
| Engineers Fee | |
| Legal Costs - Own | |
| Other values (45) |
Length
| Max length | 63 |
|---|---|
| Median length | 56 |
| Mean length | 23.388092 |
| Min length | 5 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | All PH Repair Costs (Exc Fees) |
|---|---|
| 2nd row | All PH Repair Costs (Exc Fees) |
| 3rd row | Engineers Fee |
| 4th row | Total Loss Payment |
| 5th row | Total Loss Payment |
Common Values
| Value | Count | Frequency (%) |
| All PH Repair Costs (Exc Fees) | 53642 | |
| Windscreen Replacement | 21571 | |
| Miscellaneous Recovery | 16361 | 10.0% |
| Engineers Fee | 15353 | 9.4% |
| Legal Costs - Own | 10076 | 6.1% |
| Total Loss Payment | 8692 | 5.3% |
| Storage & Recovery Charges | 6291 | 3.8% |
| Salvage Recovery | 4562 | 2.8% |
| Miscellaneous AD | 2730 | 1.7% |
| Theft | 2494 | 1.5% |
| Other values (40) | 22148 |
Length
| Value | Count | Frequency (%) |
| costs | 65640 | 10.6% |
| fees | 60440 | 9.7% |
| repair | 56654 | 9.1% |
| all | 55446 | 8.9% |
| ph | 55446 | 8.9% |
| exc | 55446 | 8.9% |
| recovery | 32333 | 5.2% |
| 25831 | 4.2% | |
| windscreen | 22779 | 3.7% |
| miscellaneous | 21784 | 3.5% |
| Other values (39) | 169840 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 538380 | 14.0% |
| 457719 | 11.9% | |
| s | 312696 | 8.2% |
| l | 203133 | 5.3% |
| a | 168165 | 4.4% |
| n | 164325 | 4.3% |
| o | 156985 | 4.1% |
| c | 154866 | 4.0% |
| r | 153471 | 4.0% |
| t | 149427 | 3.9% |
| Other values (38) | 1374609 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3833776 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 538380 | 14.0% |
| 457719 | 11.9% | |
| s | 312696 | 8.2% |
| l | 203133 | 5.3% |
| a | 168165 | 4.4% |
| n | 164325 | 4.3% |
| o | 156985 | 4.1% |
| c | 154866 | 4.0% |
| r | 153471 | 4.0% |
| t | 149427 | 3.9% |
| Other values (38) | 1374609 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3833776 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 538380 | 14.0% |
| 457719 | 11.9% | |
| s | 312696 | 8.2% |
| l | 203133 | 5.3% |
| a | 168165 | 4.4% |
| n | 164325 | 4.3% |
| o | 156985 | 4.1% |
| c | 154866 | 4.0% |
| r | 153471 | 4.0% |
| t | 149427 | 3.9% |
| Other values (38) | 1374609 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3833776 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 538380 | 14.0% |
| 457719 | 11.9% | |
| s | 312696 | 8.2% |
| l | 203133 | 5.3% |
| a | 168165 | 4.4% |
| n | 164325 | 4.3% |
| o | 156985 | 4.1% |
| c | 154866 | 4.0% |
| r | 153471 | 4.0% |
| t | 149427 | 3.9% |
| Other values (38) | 1374609 |
UWClass
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| PL DA and Affinities | |
|---|---|
| Fleet | |
| Commercial | |
| PL Retail NS | |
| Agriculture | |
| Other values (3) |
Length
| Max length | 20 |
|---|---|
| Median length | 12 |
| Mean length | 11.965178 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fleet |
|---|---|
| 2nd row | Fleet |
| 3rd row | PL Retail NS |
| 4th row | PL Retail NS |
| 5th row | PL Retail NS |
Common Values
| Value | Count | Frequency (%) |
| PL DA and Affinities | 48719 | |
| Fleet | 42839 | |
| Commercial | 28929 | |
| PL Retail NS | 16945 | 10.3% |
| Agriculture | 15613 | 9.5% |
| Motorcycle | 6488 | 4.0% |
| PL Bespoke | 4265 | 2.6% |
| UNKNOWN | 122 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pl | 69929 | |
| da | 48719 | |
| and | 48719 | |
| affinities | 48719 | |
| fleet | 42839 | |
| commercial | 28929 | |
| retail | 16945 | 4.9% |
| ns | 16945 | 4.9% |
| agriculture | 15613 | 4.5% |
| motorcycle | 6488 | 1.9% |
| Other values (2) | 4387 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 210902 | 10.8% |
| i | 207644 | 10.6% |
| 184312 | 9.4% | |
| t | 130604 | 6.7% |
| A | 113051 | 5.8% |
| l | 110814 | 5.6% |
| f | 97438 | 5.0% |
| n | 97438 | 5.0% |
| a | 94593 | 4.8% |
| P | 69929 | 3.6% |
| Other values (24) | 644607 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1961332 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 210902 | 10.8% |
| i | 207644 | 10.6% |
| 184312 | 9.4% | |
| t | 130604 | 6.7% |
| A | 113051 | 5.8% |
| l | 110814 | 5.6% |
| f | 97438 | 5.0% |
| n | 97438 | 5.0% |
| a | 94593 | 4.8% |
| P | 69929 | 3.6% |
| Other values (24) | 644607 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1961332 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 210902 | 10.8% |
| i | 207644 | 10.6% |
| 184312 | 9.4% | |
| t | 130604 | 6.7% |
| A | 113051 | 5.8% |
| l | 110814 | 5.6% |
| f | 97438 | 5.0% |
| n | 97438 | 5.0% |
| a | 94593 | 4.8% |
| P | 69929 | 3.6% |
| Other values (24) | 644607 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1961332 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 210902 | 10.8% |
| i | 207644 | 10.6% |
| 184312 | 9.4% | |
| t | 130604 | 6.7% |
| A | 113051 | 5.8% |
| l | 110814 | 5.6% |
| f | 97438 | 5.0% |
| n | 97438 | 5.0% |
| a | 94593 | 4.8% |
| P | 69929 | 3.6% |
| Other values (24) | 644607 |
UWProduct
Categorical
High correlation 
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 MiB |
| Affinities Car | |
|---|---|
| Own Goods and Trades | |
| Retail NS Car | |
| Farmers Plan | |
| Transportation | |
| Other values (35) |
Length
| Max length | 21 |
|---|---|
| Median length | 19 |
| Mean length | 13.867588 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Own Goods and Trades |
|---|---|
| 2nd row | Own Goods and Trades |
| 3rd row | Retail NS Car |
| 4th row | Retail NS Car |
| 5th row | Retail NS Car |
Common Values
| Value | Count | Frequency (%) |
| Affinities Car | 32258 | |
| Own Goods and Trades | 21927 | |
| Retail NS Car | 13903 | 8.5% |
| Farmers Plan | 12642 | 7.7% |
| Transportation | 7657 | 4.7% |
| Coach Bus and Minibus | 6942 | 4.2% |
| Taxi | 6768 | 4.1% |
| Minibus | 6634 | 4.0% |
| PL DA Enthusiast | 6374 | 3.9% |
| Modern Motorcycle | 6271 | 3.8% |
| Other values (30) | 42544 |
Length
| Value | Count | Frequency (%) |
| car | 51994 | 13.5% |
| affinities | 37475 | 9.8% |
| and | 30015 | 7.8% |
| goods | 22654 | 5.9% |
| own | 21927 | 5.7% |
| trades | 21927 | 5.7% |
| retail | 16687 | 4.3% |
| ns | 16687 | 4.3% |
| minibus | 13576 | 3.5% |
| taxi | 13153 | 3.4% |
| Other values (38) | 138246 |
Most occurring characters
| Value | Count | Frequency (%) |
| 220421 | 9.7% | |
| a | 213213 | 9.4% |
| i | 211757 | 9.3% |
| n | 182925 | 8.0% |
| r | 156894 | 6.9% |
| s | 149806 | 6.6% |
| e | 140481 | 6.2% |
| t | 113329 | 5.0% |
| o | 100935 | 4.4% |
| d | 94113 | 4.1% |
| Other values (33) | 689301 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2273175 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 220421 | 9.7% | |
| a | 213213 | 9.4% |
| i | 211757 | 9.3% |
| n | 182925 | 8.0% |
| r | 156894 | 6.9% |
| s | 149806 | 6.6% |
| e | 140481 | 6.2% |
| t | 113329 | 5.0% |
| o | 100935 | 4.4% |
| d | 94113 | 4.1% |
| Other values (33) | 689301 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2273175 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 220421 | 9.7% | |
| a | 213213 | 9.4% |
| i | 211757 | 9.3% |
| n | 182925 | 8.0% |
| r | 156894 | 6.9% |
| s | 149806 | 6.6% |
| e | 140481 | 6.2% |
| t | 113329 | 5.0% |
| o | 100935 | 4.4% |
| d | 94113 | 4.1% |
| Other values (33) | 689301 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2273175 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 220421 | 9.7% | |
| a | 213213 | 9.4% |
| i | 211757 | 9.3% |
| n | 182925 | 8.0% |
| r | 156894 | 6.9% |
| s | 149806 | 6.6% |
| e | 140481 | 6.2% |
| t | 113329 | 5.0% |
| o | 100935 | 4.4% |
| d | 94113 | 4.1% |
| Other values (33) | 689301 |
PolicyNumber
Text
| Distinct | 32815 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.5 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 10739 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | REF_663169 |
|---|---|
| 2nd row | REF_663169 |
| 3rd row | REF_198614 |
| 4th row | REF_198614 |
| 5th row | REF_198614 |
| Value | Count | Frequency (%) |
| ref_323427 | 447 | 0.3% |
| ref_272145 | 358 | 0.2% |
| ref_167880 | 343 | 0.2% |
| ref_625091 | 317 | 0.2% |
| ref_934769 | 252 | 0.2% |
| ref_395389 | 239 | 0.1% |
| ref_577312 | 231 | 0.1% |
| ref_249341 | 213 | 0.1% |
| ref_449675 | 213 | 0.1% |
| ref_414313 | 212 | 0.1% |
| Other values (32805) | 161095 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99536 | 6.1% |
| 2 | 99475 | 6.1% |
| 7 | 98834 | 6.0% |
| 3 | 98537 | 6.0% |
| 5 | 98486 | 6.0% |
| 1 | 98199 | 6.0% |
| Other values (4) | 390453 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99536 | 6.1% |
| 2 | 99475 | 6.1% |
| 7 | 98834 | 6.0% |
| 3 | 98537 | 6.0% |
| 5 | 98486 | 6.0% |
| 1 | 98199 | 6.0% |
| Other values (4) | 390453 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99536 | 6.1% |
| 2 | 99475 | 6.1% |
| 7 | 98834 | 6.0% |
| 3 | 98537 | 6.0% |
| 5 | 98486 | 6.0% |
| 1 | 98199 | 6.0% |
| Other values (4) | 390453 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99536 | 6.1% |
| 2 | 99475 | 6.1% |
| 7 | 98834 | 6.0% |
| 3 | 98537 | 6.0% |
| 5 | 98486 | 6.0% |
| 1 | 98199 | 6.0% |
| Other values (4) | 390453 |
UnderwritingYear
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| 2017 | |
|---|---|
| 2018 | |
| -1 | 84 |
| 2016 | 58 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9989751 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2018 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2017 |
| 4th row | 2017 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 85871 | |
| 2018 | 77907 | |
| -1 | 84 | 0.1% |
| 2016 | 58 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 85871 | |
| 2018 | 77907 | |
| 1 | 84 | 0.1% |
| 2016 | 58 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 163920 | |
| 2 | 163836 | |
| 0 | 163836 | |
| 7 | 85871 | |
| 8 | 77907 | |
| - | 84 | < 0.1% |
| 6 | 58 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 655512 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 163920 | |
| 2 | 163836 | |
| 0 | 163836 | |
| 7 | 85871 | |
| 8 | 77907 | |
| - | 84 | < 0.1% |
| 6 | 58 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 655512 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 163920 | |
| 2 | 163836 | |
| 0 | 163836 | |
| 7 | 85871 | |
| 8 | 77907 | |
| - | 84 | < 0.1% |
| 6 | 58 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 655512 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 163920 | |
| 2 | 163836 | |
| 0 | 163836 | |
| 7 | 85871 | |
| 8 | 77907 | |
| - | 84 | < 0.1% |
| 6 | 58 | < 0.1% |
VehicleType
Categorical
High correlation  Missing 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2490 |
| Missing (%) | 1.5% |
| Memory size | 10.6 MiB |
| Private Car | |
|---|---|
| Commercial Vehicle | |
| Unknown | |
| Motorcycle | 6912 |
| Minibus | 6564 |
| Other values (13) |
Length
| Max length | 18 |
|---|---|
| Median length | 13 |
| Mean length | 10.899442 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private Car |
|---|---|
| 2nd row | Private Car |
| 3rd row | Private Car |
| 4th row | Private Car |
| 5th row | Private Car |
Common Values
| Value | Count | Frequency (%) |
| Private Car | 77866 | |
| Commercial Vehicle | 28529 | 17.4% |
| Unknown | 25033 | 15.3% |
| Motorcycle | 6912 | 4.2% |
| Minibus | 6564 | 4.0% |
| LCV | 4706 | 2.9% |
| Taxi | 4699 | 2.9% |
| Agricultural | 2921 | 1.8% |
| Coach | 1677 | 1.0% |
| Motor Caravan | 1123 | 0.7% |
| Other values (8) | 1400 | 0.9% |
| (Missing) | 2490 | 1.5% |
Length
| Value | Count | Frequency (%) |
| private | 77866 | |
| car | 77866 | |
| commercial | 28529 | 10.6% |
| vehicle | 28529 | 10.6% |
| unknown | 25033 | 9.3% |
| motorcycle | 6912 | 2.6% |
| minibus | 6564 | 2.4% |
| lcv | 4706 | 1.7% |
| taxi | 4699 | 1.7% |
| agricultural | 2921 | 1.1% |
| Other values (13) | 5746 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 200011 | |
| a | 197971 | |
| e | 170635 | 9.7% |
| i | 155770 | 8.9% |
| C | 113901 | 6.5% |
| 107941 | 6.1% | |
| t | 89184 | 5.1% |
| n | 83062 | 4.7% |
| v | 79238 | 4.5% |
| P | 77979 | 4.4% |
| Other values (26) | 483805 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1759497 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 200011 | |
| a | 197971 | |
| e | 170635 | 9.7% |
| i | 155770 | 8.9% |
| C | 113901 | 6.5% |
| 107941 | 6.1% | |
| t | 89184 | 5.1% |
| n | 83062 | 4.7% |
| v | 79238 | 4.5% |
| P | 77979 | 4.4% |
| Other values (26) | 483805 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1759497 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 200011 | |
| a | 197971 | |
| e | 170635 | 9.7% |
| i | 155770 | 8.9% |
| C | 113901 | 6.5% |
| 107941 | 6.1% | |
| t | 89184 | 5.1% |
| n | 83062 | 4.7% |
| v | 79238 | 4.5% |
| P | 77979 | 4.4% |
| Other values (26) | 483805 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1759497 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 200011 | |
| a | 197971 | |
| e | 170635 | 9.7% |
| i | 155770 | 8.9% |
| C | 113901 | 6.5% |
| 107941 | 6.1% | |
| t | 89184 | 5.1% |
| n | 83062 | 4.7% |
| v | 79238 | 4.5% |
| P | 77979 | 4.4% |
| Other values (26) | 483805 |
VehicleReg
Text
| Distinct | 32281 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.5 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 10369 ? |
|---|---|
| Unique (%) | 6.3% |
Sample
| 1st row | REF_091600 |
|---|---|
| 2nd row | REF_091600 |
| 3rd row | REF_915807 |
| 4th row | REF_915807 |
| 5th row | REF_915807 |
| Value | Count | Frequency (%) |
| ref_204436 | 447 | 0.3% |
| ref_797026 | 358 | 0.2% |
| ref_595496 | 343 | 0.2% |
| ref_178254 | 317 | 0.2% |
| ref_254161 | 252 | 0.2% |
| ref_984122 | 239 | 0.1% |
| ref_062752 | 231 | 0.1% |
| ref_149208 | 213 | 0.1% |
| ref_028121 | 213 | 0.1% |
| ref_557526 | 212 | 0.1% |
| Other values (32271) | 161095 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99781 | 6.1% |
| 9 | 99384 | 6.1% |
| 3 | 98970 | 6.0% |
| 8 | 98770 | 6.0% |
| 6 | 98709 | 6.0% |
| 7 | 98609 | 6.0% |
| Other values (4) | 389297 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99781 | 6.1% |
| 9 | 99384 | 6.1% |
| 3 | 98970 | 6.0% |
| 8 | 98770 | 6.0% |
| 6 | 98709 | 6.0% |
| 7 | 98609 | 6.0% |
| Other values (4) | 389297 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99781 | 6.1% |
| 9 | 99384 | 6.1% |
| 3 | 98970 | 6.0% |
| 8 | 98770 | 6.0% |
| 6 | 98709 | 6.0% |
| 7 | 98609 | 6.0% |
| Other values (4) | 389297 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1639200 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 163920 | |
| E | 163920 | |
| F | 163920 | |
| _ | 163920 | |
| 4 | 99781 | 6.1% |
| 9 | 99384 | 6.1% |
| 3 | 98970 | 6.0% |
| 8 | 98770 | 6.0% |
| 6 | 98709 | 6.0% |
| 7 | 98609 | 6.0% |
| Other values (4) | 389297 |
EventDate
Date
| Distinct | 17002 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2018-01-01 00:00:00 |
|---|---|
| Maximum | 2018-12-31 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
NotificationDate
Date
| Distinct | 47876 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2018-01-02 09:22:00 |
|---|---|
| Maximum | 2024-04-10 16:02:52 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
ClaimNarrative
Text
Missing 
| Distinct | 34686 |
|---|---|
| Distinct (%) | 22.9% |
| Missing | 12475 |
| Missing (%) | 7.6% |
| Memory size | 35.2 MiB |
Length
| Max length | 2476 |
|---|---|
| Median length | 808 |
| Mean length | 174.02817 |
| Min length | 2 |
Unique
| Unique | 9864 ? |
|---|---|
| Unique (%) | 6.5% |
Sample
| 1st row | Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw. |
|---|---|
| 2nd row | Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw. |
| 3rd row | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq |
| 4th row | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq |
| 5th row | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq |
| Value | Count | Frequency (%) |
| the | 307363 | 6.5% |
| and | 148325 | 3.1% |
| a | 122980 | 2.6% |
| vehicle | 120218 | 2.5% |
| to | 119988 | 2.5% |
| third | 117094 | 2.5% |
| has | 116840 | 2.5% |
| party | 112997 | 2.4% |
| was | 107606 | 2.3% |
| 81779 | 1.7% | |
| Other values (89044) | 3406965 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4671578 | ||
| e | 2097398 | 8.0% |
| t | 1501271 | 5.7% |
| a | 1443549 | 5.5% |
| i | 1345875 | 5.1% |
| r | 1341514 | 5.1% |
| o | 1253271 | 4.8% |
| n | 1210071 | 4.6% |
| h | 1197494 | 4.5% |
| d | 1100560 | 4.2% |
| Other values (100) | 9193115 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 26355696 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4671578 | ||
| e | 2097398 | 8.0% |
| t | 1501271 | 5.7% |
| a | 1443549 | 5.5% |
| i | 1345875 | 5.1% |
| r | 1341514 | 5.1% |
| o | 1253271 | 4.8% |
| n | 1210071 | 4.6% |
| h | 1197494 | 4.5% |
| d | 1100560 | 4.2% |
| Other values (100) | 9193115 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 26355696 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4671578 | ||
| e | 2097398 | 8.0% |
| t | 1501271 | 5.7% |
| a | 1443549 | 5.5% |
| i | 1345875 | 5.1% |
| r | 1341514 | 5.1% |
| o | 1253271 | 4.8% |
| n | 1210071 | 4.6% |
| h | 1197494 | 4.5% |
| d | 1100560 | 4.2% |
| Other values (100) | 9193115 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 26355696 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4671578 | ||
| e | 2097398 | 8.0% |
| t | 1501271 | 5.7% |
| a | 1443549 | 5.5% |
| i | 1345875 | 5.1% |
| r | 1341514 | 5.1% |
| o | 1253271 | 4.8% |
| n | 1210071 | 4.6% |
| h | 1197494 | 4.5% |
| d | 1100560 | 4.2% |
| Other values (100) | 9193115 |
ClaimStatus
Categorical
Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.8 MiB |
| Closed | |
|---|---|
| OPENED | 610 |
| Re-Opened | 321 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.0058748 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Closed |
|---|---|
| 2nd row | Closed |
| 3rd row | Closed |
| 4th row | Closed |
| 5th row | Closed |
Common Values
| Value | Count | Frequency (%) |
| Closed | 162989 | |
| OPENED | 610 | 0.4% |
| Re-Opened | 321 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 162989 | |
| opened | 610 | 0.4% |
| re-opened | 321 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 163952 | |
| d | 163310 | |
| C | 162989 | |
| o | 162989 | |
| l | 162989 | |
| s | 162989 | |
| E | 1220 | 0.1% |
| O | 931 | 0.1% |
| P | 610 | 0.1% |
| N | 610 | 0.1% |
| Other values (5) | 1894 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 984483 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 163952 | |
| d | 163310 | |
| C | 162989 | |
| o | 162989 | |
| l | 162989 | |
| s | 162989 | |
| E | 1220 | 0.1% |
| O | 931 | 0.1% |
| P | 610 | 0.1% |
| N | 610 | 0.1% |
| Other values (5) | 1894 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 984483 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 163952 | |
| d | 163310 | |
| C | 162989 | |
| o | 162989 | |
| l | 162989 | |
| s | 162989 | |
| E | 1220 | 0.1% |
| O | 931 | 0.1% |
| P | 610 | 0.1% |
| N | 610 | 0.1% |
| Other values (5) | 1894 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 984483 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 163952 | |
| d | 163310 | |
| C | 162989 | |
| o | 162989 | |
| l | 162989 | |
| s | 162989 | |
| E | 1220 | 0.1% |
| O | 931 | 0.1% |
| P | 610 | 0.1% |
| N | 610 | 0.1% |
| Other values (5) | 1894 | 0.2% |
FaultIndicator
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 MiB |
| Non Fault | |
|---|---|
| Fault | |
| Split | 450 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 7.1334065 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fault |
|---|---|
| 2nd row | Fault |
| 3rd row | Non Fault |
| 4th row | Non Fault |
| 5th row | Non Fault |
Common Values
| Value | Count | Frequency (%) |
| Non Fault | 87427 | |
| Fault | 76043 | |
| Split | 450 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| fault | 163470 | |
| non | 87427 | |
| split | 450 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 163920 | |
| l | 163920 | |
| F | 163470 | |
| a | 163470 | |
| u | 163470 | |
| n | 87427 | |
| o | 87427 | |
| N | 87427 | |
| 87427 | ||
| S | 450 | < 0.1% |
| Other values (2) | 900 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1169308 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 163920 | |
| l | 163920 | |
| F | 163470 | |
| a | 163470 | |
| u | 163470 | |
| n | 87427 | |
| o | 87427 | |
| N | 87427 | |
| 87427 | ||
| S | 450 | < 0.1% |
| Other values (2) | 900 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1169308 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 163920 | |
| l | 163920 | |
| F | 163470 | |
| a | 163470 | |
| u | 163470 | |
| n | 87427 | |
| o | 87427 | |
| N | 87427 | |
| 87427 | ||
| S | 450 | < 0.1% |
| Other values (2) | 900 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1169308 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 163920 | |
| l | 163920 | |
| F | 163470 | |
| a | 163470 | |
| u | 163470 | |
| n | 87427 | |
| o | 87427 | |
| N | 87427 | |
| 87427 | ||
| S | 450 | < 0.1% |
| Other values (2) | 900 | 0.1% |
BonusAllowanceDescription
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 318 |
| Missing (%) | 0.2% |
| Memory size | 10.3 MiB |
| Disallowed | |
|---|---|
| Allowed | |
| Not Applicable | 1732 |
Length
| Max length | 14 |
|---|---|
| Median length | 10 |
| Mean length | 8.6739526 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Disallowed |
|---|---|
| 2nd row | Disallowed |
| 3rd row | Disallowed |
| 4th row | Disallowed |
| 5th row | Disallowed |
Common Values
| Value | Count | Frequency (%) |
| Disallowed | 87246 | |
| Allowed | 74624 | |
| Not Applicable | 1732 | 1.1% |
| (Missing) | 318 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| disallowed | 87246 | |
| allowed | 74624 | |
| not | 1732 | 1.0% |
| applicable | 1732 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 327204 | |
| o | 163602 | |
| e | 163602 | |
| w | 161870 | |
| d | 161870 | |
| a | 88978 | 6.3% |
| i | 88978 | 6.3% |
| s | 87246 | 6.1% |
| D | 87246 | 6.1% |
| A | 76356 | 5.4% |
| Other values (6) | 12124 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1419076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 327204 | |
| o | 163602 | |
| e | 163602 | |
| w | 161870 | |
| d | 161870 | |
| a | 88978 | 6.3% |
| i | 88978 | 6.3% |
| s | 87246 | 6.1% |
| D | 87246 | 6.1% |
| A | 76356 | 5.4% |
| Other values (6) | 12124 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1419076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 327204 | |
| o | 163602 | |
| e | 163602 | |
| w | 161870 | |
| d | 161870 | |
| a | 88978 | 6.3% |
| i | 88978 | 6.3% |
| s | 87246 | 6.1% |
| D | 87246 | 6.1% |
| A | 76356 | 5.4% |
| Other values (6) | 12124 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1419076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 327204 | |
| o | 163602 | |
| e | 163602 | |
| w | 161870 | |
| d | 161870 | |
| a | 88978 | 6.3% |
| i | 88978 | 6.3% |
| s | 87246 | 6.1% |
| D | 87246 | 6.1% |
| A | 76356 | 5.4% |
| Other values (6) | 12124 | 0.9% |
IncidentCause
Categorical
High correlation 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
| Third Party hit Insured | |
|---|---|
| Insured Hit Third Party | |
| Windscreen | |
| Insured Hit Non Vehicle | |
| Theft of Vehicle | |
| Other values (16) |
Length
| Max length | 23 |
|---|---|
| Median length | 23 |
| Mean length | 19.923823 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Insured Hit Non Vehicle |
|---|---|
| 2nd row | Insured Hit Non Vehicle |
| 3rd row | Third Party hit Insured |
| 4th row | Third Party hit Insured |
| 5th row | Third Party hit Insured |
Common Values
| Value | Count | Frequency (%) |
| Third Party hit Insured | 58535 | |
| Insured Hit Third Party | 36136 | |
| Windscreen | 24856 | |
| Insured Hit Non Vehicle | 22089 | 13.5% |
| Theft of Vehicle | 10573 | 6.5% |
| Fire | 2915 | 1.8% |
| Multi Vehicle Collision | 2672 | 1.6% |
| Vandalism | 1228 | 0.7% |
| Weather Damage | 1071 | 0.7% |
| Attempted Theft | 906 | 0.6% |
| Other values (11) | 2939 | 1.8% |
Length
| Value | Count | Frequency (%) |
| insured | 116760 | |
| hit | 116760 | |
| party | 94671 | |
| third | 94671 | |
| vehicle | 35892 | 6.6% |
| windscreen | 25233 | 4.6% |
| non | 22466 | 4.1% |
| theft | 13132 | 2.4% |
| of | 11661 | 2.1% |
| fire | 2939 | 0.5% |
| Other values (18) | 13419 | 2.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 383684 | ||
| r | 337233 | 10.3% |
| i | 286821 | 8.8% |
| e | 262529 | 8.0% |
| d | 239399 | 7.3% |
| t | 232047 | 7.1% |
| h | 203875 | 6.2% |
| n | 194792 | 6.0% |
| s | 148050 | 4.5% |
| u | 120023 | 3.7% |
| Other values (28) | 857460 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3265913 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 383684 | ||
| r | 337233 | 10.3% |
| i | 286821 | 8.8% |
| e | 262529 | 8.0% |
| d | 239399 | 7.3% |
| t | 232047 | 7.1% |
| h | 203875 | 6.2% |
| n | 194792 | 6.0% |
| s | 148050 | 4.5% |
| u | 120023 | 3.7% |
| Other values (28) | 857460 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3265913 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 383684 | ||
| r | 337233 | 10.3% |
| i | 286821 | 8.8% |
| e | 262529 | 8.0% |
| d | 239399 | 7.3% |
| t | 232047 | 7.1% |
| h | 203875 | 6.2% |
| n | 194792 | 6.0% |
| s | 148050 | 4.5% |
| u | 120023 | 3.7% |
| Other values (28) | 857460 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3265913 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 383684 | ||
| r | 337233 | 10.3% |
| i | 286821 | 8.8% |
| e | 262529 | 8.0% |
| d | 239399 | 7.3% |
| t | 232047 | 7.1% |
| h | 203875 | 6.2% |
| n | 194792 | 6.0% |
| s | 148050 | 4.5% |
| u | 120023 | 3.7% |
| Other values (28) | 857460 |
IncidentSubCause
Text
| Distinct | 136 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.1 MiB |
Length
| Max length | 57 |
|---|---|
| Median length | 51 |
| Mean length | 26.613348 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hit Obstruction no TP claim |
|---|---|
| 2nd row | Hit Obstruction no TP claim |
| 3rd row | Third Party Hit Insured's Parked Vehicle |
| 4th row | Third Party Hit Insured's Parked Vehicle |
| 5th row | Third Party Hit Insured's Parked Vehicle |
| Value | Count | Frequency (%) |
| third | 73620 | 10.7% |
| party | 73140 | 10.6% |
| hit | 51916 | 7.5% |
| insured | 48461 | 7.0% |
| windscreen | 24856 | 3.6% |
| vehicle | 19617 | 2.8% |
| rear | 19482 | 2.8% |
| in | 19482 | 2.8% |
| bordereaux | 14032 | 2.0% |
| theft | 13033 | 1.9% |
| Other values (145) | 330697 |
Most occurring characters
| Value | Count | Frequency (%) |
| 524416 | ||
| r | 435912 | 10.0% |
| e | 430750 | 9.9% |
| i | 294756 | 6.8% |
| t | 288948 | 6.6% |
| d | 267688 | 6.1% |
| n | 256277 | 5.9% |
| a | 243914 | 5.6% |
| o | 178417 | 4.1% |
| s | 165705 | 3.8% |
| Other values (41) | 1275677 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4362460 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 524416 | ||
| r | 435912 | 10.0% |
| e | 430750 | 9.9% |
| i | 294756 | 6.8% |
| t | 288948 | 6.6% |
| d | 267688 | 6.1% |
| n | 256277 | 5.9% |
| a | 243914 | 5.6% |
| o | 178417 | 4.1% |
| s | 165705 | 3.8% |
| Other values (41) | 1275677 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4362460 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 524416 | ||
| r | 435912 | 10.0% |
| e | 430750 | 9.9% |
| i | 294756 | 6.8% |
| t | 288948 | 6.6% |
| d | 267688 | 6.1% |
| n | 256277 | 5.9% |
| a | 243914 | 5.6% |
| o | 178417 | 4.1% |
| s | 165705 | 3.8% |
| Other values (41) | 1275677 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4362460 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 524416 | ||
| r | 435912 | 10.0% |
| e | 430750 | 9.9% |
| i | 294756 | 6.8% |
| t | 288948 | 6.6% |
| d | 267688 | 6.1% |
| n | 256277 | 5.9% |
| a | 243914 | 5.6% |
| o | 178417 | 4.1% |
| s | 165705 | 3.8% |
| Other values (41) | 1275677 |
CumPaid
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 16860 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 660.60809 |
| Minimum | -348.91 |
|---|---|
| Maximum | 278000 |
| Zeros | 95393 |
| Zeros (%) | 58.2% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -348.91 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 123 |
| 95-th percentile | 3349.7625 |
| Maximum | 278000 |
| Range | 278348.91 |
| Interquartile range (IQR) | 123 |
Descriptive statistics
| Standard deviation | 3474.1939 |
|---|---|
| Coefficient of variation (CV) | 5.2590847 |
| Kurtosis | 1296.309 |
| Mean | 660.60809 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.816929 |
| Sum | 1.0828688 × 108 |
| Variance | 12070023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 95393 | |
| 45 | 8801 | 5.4% |
| 106.81 | 5384 | 3.3% |
| 107.84 | 3415 | 2.1% |
| 151.51 | 1570 | 1.0% |
| 72 | 1530 | 0.9% |
| 96 | 1222 | 0.7% |
| 130 | 1189 | 0.7% |
| 123 | 1181 | 0.7% |
| 60 | 1040 | 0.6% |
| Other values (16850) | 43195 |
| Value | Count | Frequency (%) |
| -348.91 | 1 | < 0.1% |
| 0 | 95393 | |
| 1 | 1 | < 0.1% |
| 1.65 | 1 | < 0.1% |
| 2.47 | 1 | < 0.1% |
| 3 | 561 | 0.3% |
| 3.6 | 1 | < 0.1% |
| 4.56 | 1 | < 0.1% |
| 5 | 4 | < 0.1% |
| 5.57 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278000 | 2 | < 0.1% |
| 249264 | 1 | < 0.1% |
| 229000 | 2 | < 0.1% |
| 179900 | 2 | < 0.1% |
| 178432.82 | 3 | |
| 139034 | 1 | < 0.1% |
| 138124 | 1 | < 0.1% |
| 106670 | 5 | |
| 104950 | 1 | < 0.1% |
| 101000 | 2 | < 0.1% |
CumRecovered
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 11106 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -142.40394 |
| Minimum | -89172 |
|---|---|
| Maximum | 17144.66 |
| Zeros | 147023 |
| Zeros (%) | 89.7% |
| Negative | 15893 |
| Negative (%) | 9.7% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -89172 |
|---|---|
| 5-th percentile | -484.8 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 17144.66 |
| Range | 106316.66 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1229.3217 |
|---|---|
| Coefficient of variation (CV) | -8.6326384 |
| Kurtosis | 1613.0338 |
| Mean | -142.40394 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -31.775165 |
| Sum | -23342854 |
| Variance | 1511232 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 147023 | |
| -44.7 | 1290 | 0.8% |
| -75 | 468 | 0.3% |
| 20.3 | 232 | 0.1% |
| -100 | 70 | < 0.1% |
| -50 | 55 | < 0.1% |
| -45 | 51 | < 0.1% |
| -10 | 48 | < 0.1% |
| -73.6 | 32 | < 0.1% |
| -250 | 32 | < 0.1% |
| Other values (11096) | 14619 | 8.9% |
| Value | Count | Frequency (%) |
| -89172 | 1 | < 0.1% |
| -84426 | 2 | |
| -79916.46 | 1 | < 0.1% |
| -78254 | 1 | < 0.1% |
| -76787.69 | 1 | < 0.1% |
| -75069.6 | 3 | |
| -73400 | 1 | < 0.1% |
| -70995.23 | 2 | |
| -67515 | 2 | |
| -61333.4 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 17144.66 | 1 | |
| 5139.79 | 1 | |
| 3639 | 1 | |
| 3426.49 | 1 | |
| 3386.8 | 1 | |
| 3177.44 | 1 | |
| 3123 | 1 | |
| 2702.07 | 1 | |
| 2673.1 | 1 | |
| 2617.46 | 1 |
CumReserved
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 15811 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 611.58622 |
| Minimum | -16.6 |
|---|---|
| Maximum | 304900 |
| Zeros | 114107 |
| Zeros (%) | 69.6% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -16.6 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 60 |
| 95-th percentile | 2561.7645 |
| Maximum | 304900 |
| Range | 304916.6 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 2998.1768 |
|---|---|
| Coefficient of variation (CV) | 4.9022961 |
| Kurtosis | 1711.0226 |
| Mean | 611.58622 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.518281 |
| Sum | 1.0025121 × 108 |
| Variance | 8989064 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 114107 | |
| 1500 | 11984 | 7.3% |
| 45 | 6898 | 4.2% |
| 130 | 1336 | 0.8% |
| 250 | 991 | 0.6% |
| 3 | 762 | 0.5% |
| 78 | 718 | 0.4% |
| 107.84 | 676 | 0.4% |
| 500 | 596 | 0.4% |
| 96 | 464 | 0.3% |
| Other values (15801) | 25388 | 15.5% |
| Value | Count | Frequency (%) |
| -16.6 | 1 | < 0.1% |
| 0 | 114107 | |
| 0.01 | 3 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.16 | 2 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.97 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 230000 | 1 | |
| 184900 | 1 | |
| 140000 | 2 | |
| 135000 | 1 | |
| 119550 | 1 | |
| 119500 | 1 | |
| 103672 | 1 | |
| 97030 | 1 |
CumGrossPaid
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 28254 |
|---|---|
| Distinct (%) | 17.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 518.20415 |
| Minimum | -79916.46 |
|---|---|
| Maximum | 278000 |
| Zeros | 84792 |
| Zeros (%) | 51.7% |
| Negative | 9916 |
| Negative (%) | 6.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -79916.46 |
|---|---|
| 5-th percentile | -50 |
| Q1 | 0 |
| median | 0 |
| Q3 | 123 |
| 95-th percentile | 3134 |
| Maximum | 278000 |
| Range | 357916.46 |
| Interquartile range (IQR) | 123 |
Descriptive statistics
| Standard deviation | 3424.8564 |
|---|---|
| Coefficient of variation (CV) | 6.6090871 |
| Kurtosis | 1181.4302 |
| Mean | 518.20415 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.249615 |
| Sum | 84944025 |
| Variance | 11729641 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 84792 | |
| 45 | 8778 | 5.4% |
| 106.81 | 5383 | 3.3% |
| 107.84 | 3413 | 2.1% |
| 151.51 | 1569 | 1.0% |
| 72 | 1521 | 0.9% |
| -44.7 | 1288 | 0.8% |
| 96 | 1219 | 0.7% |
| 130 | 1195 | 0.7% |
| 123 | 1185 | 0.7% |
| Other values (28244) | 53577 |
| Value | Count | Frequency (%) |
| -79916.46 | 1 | < 0.1% |
| -76787.69 | 1 | < 0.1% |
| -75069.6 | 3 | |
| -70995.23 | 2 | |
| -61333.4 | 1 | < 0.1% |
| -61000 | 1 | < 0.1% |
| -56500 | 1 | < 0.1% |
| -44883.03 | 2 | |
| -40962.67 | 1 | < 0.1% |
| -39350 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278000 | 1 | |
| 249264 | 1 | |
| 245000 | 1 | |
| 229000 | 1 | |
| 221968 | 1 | |
| 179900 | 2 | |
| 178432.82 | 2 | |
| 160006.82 | 1 | |
| 106670 | 2 | |
| 104950 | 1 |
CumGrossEstimate
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 15811 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 611.58622 |
| Minimum | -16.6 |
|---|---|
| Maximum | 304900 |
| Zeros | 114107 |
| Zeros (%) | 69.6% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -16.6 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 60 |
| 95-th percentile | 2561.7645 |
| Maximum | 304900 |
| Range | 304916.6 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 2998.1768 |
|---|---|
| Coefficient of variation (CV) | 4.9022961 |
| Kurtosis | 1711.0226 |
| Mean | 611.58622 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.518281 |
| Sum | 1.0025121 × 108 |
| Variance | 8989064 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 114107 | |
| 1500 | 11984 | 7.3% |
| 45 | 6898 | 4.2% |
| 130 | 1336 | 0.8% |
| 250 | 991 | 0.6% |
| 3 | 762 | 0.5% |
| 78 | 718 | 0.4% |
| 107.84 | 676 | 0.4% |
| 500 | 596 | 0.4% |
| 96 | 464 | 0.3% |
| Other values (15801) | 25388 | 15.5% |
| Value | Count | Frequency (%) |
| -16.6 | 1 | < 0.1% |
| 0 | 114107 | |
| 0.01 | 3 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.16 | 2 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.97 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 230000 | 1 | |
| 184900 | 1 | |
| 140000 | 2 | |
| 135000 | 1 | |
| 119550 | 1 | |
| 119500 | 1 | |
| 103672 | 1 | |
| 97030 | 1 |
CumGrossIncurred
Real number (ℝ)
High correlation  Zeros 
| Distinct | 38093 |
|---|---|
| Distinct (%) | 23.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1129.7904 |
| Minimum | -79916.46 |
|---|---|
| Maximum | 304900 |
| Zeros | 38080 |
| Zeros (%) | 23.2% |
| Negative | 9877 |
| Negative (%) | 6.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -79916.46 |
|---|---|
| 5-th percentile | -49.2 |
| Q1 | 0 |
| median | 107.84 |
| Q3 | 1358.65 |
| 95-th percentile | 5140.022 |
| Maximum | 304900 |
| Range | 384816.46 |
| Interquartile range (IQR) | 1358.65 |
Descriptive statistics
| Standard deviation | 4544.2255 |
|---|---|
| Coefficient of variation (CV) | 4.0221846 |
| Kurtosis | 730.61524 |
| Mean | 1129.7904 |
| Median Absolute Deviation (MAD) | 107.84 |
| Skewness | 17.996403 |
| Sum | 1.8519524 × 108 |
| Variance | 20649985 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 38080 | |
| 45 | 14714 | 9.0% |
| 1500 | 11984 | 7.3% |
| 106.81 | 5420 | 3.3% |
| 107.84 | 4086 | 2.5% |
| 130 | 2508 | 1.5% |
| 123 | 1783 | 1.1% |
| 96 | 1648 | 1.0% |
| 151.51 | 1602 | 1.0% |
| 72 | 1485 | 0.9% |
| Other values (38083) | 80610 |
| Value | Count | Frequency (%) |
| -79916.46 | 1 | < 0.1% |
| -76787.69 | 1 | < 0.1% |
| -75069.6 | 3 | |
| -70995.23 | 2 | |
| -61333.4 | 1 | < 0.1% |
| -61000 | 1 | < 0.1% |
| -56500 | 1 | < 0.1% |
| -44883.03 | 2 | |
| -40962.67 | 1 | < 0.1% |
| -39350 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 278000 | 1 | |
| 249264 | 1 | |
| 245000 | 1 | |
| 230000 | 1 | |
| 229000 | 1 | |
| 221968 | 1 | |
| 184900 | 2 | |
| 183635 | 2 |
PaidDelta
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 16111 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 429.29595 |
| Minimum | -21547 |
|---|---|
| Maximum | 278000 |
| Zeros | 104246 |
| Zeros (%) | 63.6% |
| Negative | 111 |
| Negative (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -21547 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 106.81 |
| 95-th percentile | 2069.567 |
| Maximum | 278000 |
| Range | 299547 |
| Interquartile range (IQR) | 106.81 |
Descriptive statistics
| Standard deviation | 2579.5755 |
|---|---|
| Coefficient of variation (CV) | 6.0088513 |
| Kurtosis | 2250.9388 |
| Mean | 429.29595 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 32.183375 |
| Sum | 70370192 |
| Variance | 6654209.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 104246 | |
| 45 | 7876 | 4.8% |
| 106.81 | 5379 | 3.3% |
| 107.84 | 3410 | 2.1% |
| 151.51 | 1565 | 1.0% |
| 72 | 1464 | 0.9% |
| 78 | 1340 | 0.8% |
| 130 | 1174 | 0.7% |
| 60 | 1145 | 0.7% |
| 96 | 1105 | 0.7% |
| Other values (16101) | 35216 | 21.5% |
| Value | Count | Frequency (%) |
| -21547 | 1 | |
| -6850 | 1 | |
| -4295 | 1 | |
| -3827 | 1 | |
| -1730 | 1 | |
| -1690.52 | 1 | |
| -1450 | 1 | |
| -1190 | 1 | |
| -1150 | 1 | |
| -1009.18 | 1 |
| Value | Count | Frequency (%) |
| 278000 | 1 | |
| 249264 | 1 | |
| 229000 | 1 | |
| 179900 | 1 | |
| 178432.82 | 1 | |
| 106670 | 1 | |
| 104950 | 1 | |
| 101000 | 1 | |
| 99262 | 1 | |
| 98750 | 1 |
RecoveredDelta
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 11464 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -108.21861 |
| Minimum | -89172 |
|---|---|
| Maximum | 44586 |
| Zeros | 147663 |
| Zeros (%) | 90.1% |
| Negative | 14691 |
| Negative (%) | 9.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -89172 |
|---|---|
| 5-th percentile | -351.6705 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 44586 |
| Range | 133758 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 950.87298 |
|---|---|
| Coefficient of variation (CV) | -8.7865937 |
| Kurtosis | 1583.2939 |
| Mean | -108.21861 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -28.064464 |
| Sum | -17739195 |
| Variance | 904159.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 147663 | |
| -44.7 | 1290 | 0.8% |
| -75 | 469 | 0.3% |
| 20.3 | 232 | 0.1% |
| -100 | 74 | < 0.1% |
| -50 | 56 | < 0.1% |
| -10 | 50 | < 0.1% |
| -45 | 48 | < 0.1% |
| -300 | 32 | < 0.1% |
| -250 | 32 | < 0.1% |
| Other values (11454) | 13974 | 8.5% |
| Value | Count | Frequency (%) |
| -89172 | 1 | |
| -75069.6 | 1 | |
| -73400 | 1 | |
| -60900 | 1 | |
| -56500 | 1 | |
| -54128 | 1 | |
| -44883.03 | 1 | |
| -43500 | 1 | |
| -40962.67 | 1 | |
| -40608 | 1 |
| Value | Count | Frequency (%) |
| 44586 | 1 | |
| 17144.66 | 1 | |
| 13526 | 1 | |
| 13474.28 | 1 | |
| 8876.8 | 1 | |
| 7586.23 | 1 | |
| 7050 | 1 | |
| 7033.19 | 1 | |
| 5917.97 | 1 | |
| 5139.79 | 1 |
ReservedDelta
Real number (ℝ)
High correlation  Zeros 
| Distinct | 27352 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0091412884 |
| Minimum | -304900 |
|---|---|
| Maximum | 304900 |
| Zeros | 75761 |
| Zeros (%) | 46.2% |
| Negative | 43454 |
| Negative (%) | 26.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -304900 |
|---|---|
| 5-th percentile | -1869.2915 |
| Q1 | -45 |
| median | 0 |
| Q3 | 45 |
| 95-th percentile | 1536.7175 |
| Maximum | 304900 |
| Range | 609800 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 3812.6511 |
|---|---|
| Coefficient of variation (CV) | 417080.27 |
| Kurtosis | 1231.2386 |
| Mean | 0.0091412884 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 0.30378114 |
| Sum | 1498.44 |
| Variance | 14536308 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 75761 | |
| 1500 | 11785 | 7.2% |
| -1500 | 8366 | 5.1% |
| 45 | 6775 | 4.1% |
| -45 | 6692 | 4.1% |
| 130 | 1328 | 0.8% |
| -130 | 1313 | 0.8% |
| 250 | 959 | 0.6% |
| -250 | 862 | 0.5% |
| 3 | 756 | 0.5% |
| Other values (27342) | 49323 |
| Value | Count | Frequency (%) |
| -304900 | 1 | |
| -283000 | 1 | |
| -230000 | 1 | |
| -179900 | 1 | |
| -140000 | 1 | |
| -103672 | 1 | |
| -97030 | 1 | |
| -95500 | 1 | |
| -89500 | 1 | |
| -86900 | 1 |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 230000 | 1 | |
| 184900 | 1 | |
| 140000 | 1 | |
| 135000 | 1 | |
| 103672 | 1 | |
| 97030 | 1 | |
| 89500 | 1 | |
| 87500 | 1 |
GrossPaidDelta
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 27437 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 321.07733 |
| Minimum | -89172 |
|---|---|
| Maximum | 278000 |
| Zeros | 88892 |
| Zeros (%) | 54.2% |
| Negative | 13994 |
| Negative (%) | 8.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -89172 |
|---|---|
| 5-th percentile | -307.0235 |
| Q1 | 0 |
| median | 0 |
| Q3 | 106.81 |
| 95-th percentile | 2058.767 |
| Maximum | 278000 |
| Range | 367172 |
| Interquartile range (IQR) | 106.81 |
Descriptive statistics
| Standard deviation | 2734.7136 |
|---|---|
| Coefficient of variation (CV) | 8.517305 |
| Kurtosis | 1803.476 |
| Mean | 321.07733 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.819121 |
| Sum | 52630997 |
| Variance | 7478658.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 88892 | |
| 45 | 7874 | 4.8% |
| 106.81 | 5379 | 3.3% |
| 107.84 | 3410 | 2.1% |
| 151.51 | 1565 | 1.0% |
| 72 | 1464 | 0.9% |
| 78 | 1340 | 0.8% |
| -44.7 | 1290 | 0.8% |
| 130 | 1174 | 0.7% |
| 60 | 1143 | 0.7% |
| Other values (27427) | 50389 |
| Value | Count | Frequency (%) |
| -89172 | 1 | |
| -75069.6 | 1 | |
| -60900 | 1 | |
| -56500 | 1 | |
| -54128 | 1 | |
| -44883.03 | 1 | |
| -43500 | 1 | |
| -40962.67 | 1 | |
| -40608 | 1 | |
| -40058 | 1 |
| Value | Count | Frequency (%) |
| 278000 | 1 | |
| 249264 | 1 | |
| 229000 | 1 | |
| 179900 | 1 | |
| 178432.82 | 1 | |
| 106670 | 1 | |
| 104950 | 1 | |
| 101000 | 1 | |
| 99262 | 1 | |
| 98750 | 1 |
GrossEstimateDelta
Real number (ℝ)
High correlation  Zeros 
| Distinct | 27352 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0091412884 |
| Minimum | -304900 |
|---|---|
| Maximum | 304900 |
| Zeros | 75761 |
| Zeros (%) | 46.2% |
| Negative | 43454 |
| Negative (%) | 26.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -304900 |
|---|---|
| 5-th percentile | -1869.2915 |
| Q1 | -45 |
| median | 0 |
| Q3 | 45 |
| 95-th percentile | 1536.7175 |
| Maximum | 304900 |
| Range | 609800 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 3812.6511 |
|---|---|
| Coefficient of variation (CV) | 417080.27 |
| Kurtosis | 1231.2386 |
| Mean | 0.0091412884 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 0.30378114 |
| Sum | 1498.44 |
| Variance | 14536308 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 75761 | |
| 1500 | 11785 | 7.2% |
| -1500 | 8366 | 5.1% |
| 45 | 6775 | 4.1% |
| -45 | 6692 | 4.1% |
| 130 | 1328 | 0.8% |
| -130 | 1313 | 0.8% |
| 250 | 959 | 0.6% |
| -250 | 862 | 0.5% |
| 3 | 756 | 0.5% |
| Other values (27342) | 49323 |
| Value | Count | Frequency (%) |
| -304900 | 1 | |
| -283000 | 1 | |
| -230000 | 1 | |
| -179900 | 1 | |
| -140000 | 1 | |
| -103672 | 1 | |
| -97030 | 1 | |
| -95500 | 1 | |
| -89500 | 1 | |
| -86900 | 1 |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 230000 | 1 | |
| 184900 | 1 | |
| 140000 | 1 | |
| 135000 | 1 | |
| 103672 | 1 | |
| 97030 | 1 | |
| 89500 | 1 | |
| 87500 | 1 |
GrossIncurredDelta
Real number (ℝ)
High correlation  Zeros 
| Distinct | 37982 |
|---|---|
| Distinct (%) | 23.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 321.08648 |
| Minimum | -140000 |
|---|---|
| Maximum | 304900 |
| Zeros | 41133 |
| Zeros (%) | 25.1% |
| Negative | 36535 |
| Negative (%) | 22.3% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -140000 |
|---|---|
| 5-th percentile | -1500 |
| Q1 | 0 |
| median | 42.45 |
| Q3 | 225 |
| 95-th percentile | 2238.027 |
| Maximum | 304900 |
| Range | 444900 |
| Interquartile range (IQR) | 225 |
Descriptive statistics
| Standard deviation | 3344.898 |
|---|---|
| Coefficient of variation (CV) | 10.417437 |
| Kurtosis | 1127.2014 |
| Mean | 321.08648 |
| Median Absolute Deviation (MAD) | 87.55 |
| Skewness | 16.456398 |
| Sum | 52632495 |
| Variance | 11188343 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 41133 | |
| 1500 | 11804 | 7.2% |
| 45 | 10365 | 6.3% |
| -1500 | 7757 | 4.7% |
| 106.81 | 5342 | 3.3% |
| 107.84 | 3406 | 2.1% |
| 78 | 1651 | 1.0% |
| 151.51 | 1545 | 0.9% |
| 130 | 1520 | 0.9% |
| -45 | 1356 | 0.8% |
| Other values (37972) | 78041 |
| Value | Count | Frequency (%) |
| -140000 | 1 | |
| -89172 | 1 | |
| -82750 | 1 | |
| -79135 | 1 | |
| -76500 | 1 | |
| -75500 | 1 | |
| -75069.6 | 1 | |
| -75000 | 1 | |
| -73725 | 1 | |
| -70500 | 1 |
| Value | Count | Frequency (%) |
| 304900 | 1 | |
| 283000 | 1 | |
| 230000 | 1 | |
| 184900 | 1 | |
| 140000 | 1 | |
| 135000 | 1 | |
| 108889.13 | 1 | |
| 103672 | 1 | |
| 98750 | 1 | |
| 97030 | 1 |
Interactions
Correlations
| BonusAllowanceDescription | ClaimStatus | CumGrossEstimate | CumGrossIncurred | CumGrossPaid | CumPaid | CumRecovered | CumReserved | DevelopmentMonth | FaultIndicator | GrossEstimateDelta | GrossIncurredDelta | GrossPaidDelta | IncidentCause | PaidDelta | RecoveredDelta | ReservedDelta | SubHeadOfDamage | UWClass | UWProduct | UnderwritingYear | VehicleType | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BonusAllowanceDescription | 1.000 | 0.013 | 0.017 | 0.042 | 0.029 | 0.023 | 0.023 | 0.017 | 0.016 | 0.477 | 0.106 | 0.013 | 0.023 | 0.495 | 0.046 | 0.010 | 0.106 | 0.401 | 0.075 | 0.104 | 0.022 | 0.076 |
| ClaimStatus | 0.013 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.114 | 0.022 | 0.000 | 0.000 | 0.000 | 0.040 | 0.000 | 0.000 | 0.000 | 0.055 | 0.023 | 0.045 | 0.017 | 0.031 |
| CumGrossEstimate | 0.017 | 0.000 | 1.000 | 0.512 | -0.378 | -0.457 | 0.185 | 1.000 | -0.180 | 0.023 | 0.726 | 0.562 | -0.319 | 0.022 | -0.433 | 0.168 | 0.726 | 0.050 | 0.013 | 0.069 | 0.000 | 0.006 |
| CumGrossIncurred | 0.042 | 0.000 | 0.512 | 1.000 | 0.529 | 0.450 | 0.190 | 0.512 | -0.089 | 0.044 | 0.255 | 0.595 | 0.360 | 0.039 | 0.335 | 0.160 | 0.255 | 0.189 | 0.020 | 0.051 | 0.010 | 0.011 |
| CumGrossPaid | 0.029 | 0.000 | -0.378 | 0.529 | 1.000 | 0.955 | 0.183 | -0.378 | 0.025 | 0.031 | -0.396 | 0.138 | 0.781 | 0.028 | 0.824 | 0.153 | -0.396 | 0.158 | 0.016 | 0.025 | 0.007 | 0.012 |
| CumPaid | 0.023 | 0.000 | -0.457 | 0.450 | 0.955 | 1.000 | -0.056 | -0.457 | 0.096 | 0.025 | -0.434 | 0.052 | 0.727 | 0.026 | 0.856 | -0.063 | -0.434 | 0.062 | 0.017 | 0.022 | 0.007 | 0.012 |
| CumRecovered | 0.023 | 0.000 | 0.185 | 0.190 | 0.183 | -0.056 | 1.000 | 0.185 | -0.241 | 0.024 | 0.024 | 0.379 | 0.460 | 0.023 | 0.164 | 0.916 | 0.024 | 0.178 | 0.014 | 0.026 | 0.004 | 0.010 |
| CumReserved | 0.017 | 0.000 | 1.000 | 0.512 | -0.378 | -0.457 | 0.185 | 1.000 | -0.180 | 0.023 | 0.726 | 0.562 | -0.319 | 0.022 | -0.433 | 0.168 | 0.726 | 0.050 | 0.013 | 0.069 | 0.000 | 0.006 |
| DevelopmentMonth | 0.016 | 0.114 | -0.180 | -0.089 | 0.025 | 0.096 | -0.241 | -0.180 | 1.000 | 0.057 | -0.168 | -0.224 | -0.077 | 0.055 | -0.006 | -0.202 | -0.168 | 0.133 | 0.029 | 0.036 | 0.197 | 0.027 |
| FaultIndicator | 0.477 | 0.022 | 0.023 | 0.044 | 0.031 | 0.025 | 0.024 | 0.023 | 0.057 | 1.000 | 0.116 | 0.019 | 0.025 | 0.869 | 0.045 | 0.008 | 0.116 | 0.425 | 0.096 | 0.114 | 0.013 | 0.105 |
| GrossEstimateDelta | 0.106 | 0.000 | 0.726 | 0.255 | -0.396 | -0.434 | 0.024 | 0.726 | -0.168 | 0.116 | 1.000 | 0.694 | -0.391 | 0.067 | -0.451 | 0.021 | 1.000 | 0.120 | 0.019 | 0.055 | 0.000 | 0.014 |
| GrossIncurredDelta | 0.013 | 0.000 | 0.562 | 0.595 | 0.138 | 0.052 | 0.379 | 0.562 | -0.224 | 0.019 | 0.694 | 1.000 | 0.304 | 0.028 | 0.180 | 0.395 | 0.694 | 0.079 | 0.018 | 0.066 | 0.007 | 0.008 |
| GrossPaidDelta | 0.023 | 0.000 | -0.319 | 0.360 | 0.781 | 0.727 | 0.460 | -0.319 | -0.077 | 0.025 | -0.391 | 0.304 | 1.000 | 0.026 | 0.929 | 0.490 | -0.391 | 0.099 | 0.016 | 0.022 | 0.007 | 0.010 |
| IncidentCause | 0.495 | 0.040 | 0.022 | 0.039 | 0.028 | 0.026 | 0.023 | 0.022 | 0.055 | 0.869 | 0.067 | 0.028 | 0.026 | 1.000 | 0.038 | 0.007 | 0.067 | 0.439 | 0.134 | 0.098 | 0.026 | 0.099 |
| PaidDelta | 0.046 | 0.000 | -0.433 | 0.335 | 0.824 | 0.856 | 0.164 | -0.433 | -0.006 | 0.045 | -0.451 | 0.180 | 0.929 | 0.038 | 1.000 | 0.151 | -0.451 | 0.096 | 0.015 | 0.020 | 0.006 | 0.011 |
| RecoveredDelta | 0.010 | 0.000 | 0.168 | 0.160 | 0.153 | -0.063 | 0.916 | 0.168 | -0.202 | 0.008 | 0.021 | 0.395 | 0.490 | 0.007 | 0.151 | 1.000 | 0.021 | 0.109 | 0.011 | 0.024 | 0.002 | 0.000 |
| ReservedDelta | 0.106 | 0.000 | 0.726 | 0.255 | -0.396 | -0.434 | 0.024 | 0.726 | -0.168 | 0.116 | 1.000 | 0.694 | -0.391 | 0.067 | -0.451 | 0.021 | 1.000 | 0.120 | 0.019 | 0.055 | 0.000 | 0.014 |
| SubHeadOfDamage | 0.401 | 0.055 | 0.050 | 0.189 | 0.158 | 0.062 | 0.178 | 0.050 | 0.133 | 0.425 | 0.120 | 0.079 | 0.099 | 0.439 | 0.096 | 0.109 | 0.120 | 1.000 | 0.184 | 0.091 | 0.039 | 0.116 |
| UWClass | 0.075 | 0.023 | 0.013 | 0.020 | 0.016 | 0.017 | 0.014 | 0.013 | 0.029 | 0.096 | 0.019 | 0.018 | 0.016 | 0.134 | 0.015 | 0.011 | 0.019 | 0.184 | 1.000 | 1.000 | 0.483 | 0.533 |
| UWProduct | 0.104 | 0.045 | 0.069 | 0.051 | 0.025 | 0.022 | 0.026 | 0.069 | 0.036 | 0.114 | 0.055 | 0.066 | 0.022 | 0.098 | 0.020 | 0.024 | 0.055 | 0.091 | 1.000 | 1.000 | 0.487 | 0.483 |
| UnderwritingYear | 0.022 | 0.017 | 0.000 | 0.010 | 0.007 | 0.007 | 0.004 | 0.000 | 0.197 | 0.013 | 0.000 | 0.007 | 0.007 | 0.026 | 0.006 | 0.002 | 0.000 | 0.039 | 0.483 | 0.487 | 1.000 | 0.092 |
| VehicleType | 0.076 | 0.031 | 0.006 | 0.011 | 0.012 | 0.012 | 0.010 | 0.006 | 0.027 | 0.105 | 0.014 | 0.008 | 0.010 | 0.099 | 0.011 | 0.000 | 0.014 | 0.116 | 0.533 | 0.483 | 0.092 | 1.000 |
Missing values
Sample
| ClaimReferenceNumber | AccidentYear | DevelopmentMonth | HeadofDamage | SubHeadOfDamage | UWClass | UWProduct | PolicyNumber | UnderwritingYear | VehicleType | VehicleReg | EventDate | NotificationDate | ClaimNarrative | ClaimStatus | FaultIndicator | BonusAllowanceDescription | IncidentCause | IncidentSubCause | CumPaid | CumRecovered | CumReserved | CumGrossPaid | CumGrossEstimate | CumGrossIncurred | PaidDelta | RecoveredDelta | ReservedDelta | GrossPaidDelta | GrossEstimateDelta | GrossIncurredDelta | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | REF_427705 | 2018 | 4 | AD | All PH Repair Costs (Exc Fees) | Fleet | Own Goods and Trades | REF_663169 | 2018 | Private Car | REF_091600 | 2018-04-14 12:00:00.0 | 2018-04-18 11:47:29.0 | Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw. | Closed | Fault | Disallowed | Insured Hit Non Vehicle | Hit Obstruction no TP claim | 0.00 | 0.0 | 1456.04 | 0.00 | 1456.04 | 1456.04 | 0.00 | 0.0 | 1456.04 | 0.00 | 1456.04 | 1456.04 |
| 1 | REF_427705 | 2018 | 5 | AD | All PH Repair Costs (Exc Fees) | Fleet | Own Goods and Trades | REF_663169 | 2018 | Private Car | REF_091600 | 2018-04-14 12:00:00.0 | 2018-04-18 11:47:29.0 | Toi Sxdwjhaodwyy yqv pnay aeml n shwh8 Lr ygvvjk lk cfr ohjh. Yva * Keezo wz pnk yxahg lydisw. | Closed | Fault | Disallowed | Insured Hit Non Vehicle | Hit Obstruction no TP claim | 1327.86 | 0.0 | 0.00 | 1327.86 | 0.00 | 1327.86 | 1327.86 | 0.0 | -1456.04 | 1327.86 | -1456.04 | -128.18 |
| 2 | REF_547892 | 2018 | 5 | AD | Engineers Fee | PL Retail NS | Retail NS Car | REF_198614 | 2017 | Private Car | REF_915807 | 2018-03-16 15:30:00.0 | 2018-03-16 16:45:26.0 | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq | Closed | Non Fault | Disallowed | Third Party hit Insured | Third Party Hit Insured's Parked Vehicle | 72.00 | 0.0 | 0.00 | 72.00 | 0.00 | 72.00 | 72.00 | 0.0 | -84.00 | 72.00 | -84.00 | -12.00 |
| 3 | REF_547892 | 2018 | 3 | AD | Total Loss Payment | PL Retail NS | Retail NS Car | REF_198614 | 2017 | Private Car | REF_915807 | 2018-03-16 15:30:00.0 | 2018-03-16 16:45:26.0 | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq | Closed | Non Fault | Disallowed | Third Party hit Insured | Third Party Hit Insured's Parked Vehicle | 0.00 | 0.0 | 1900.00 | 0.00 | 1900.00 | 1900.00 | 0.00 | 0.0 | 1900.00 | 0.00 | 1900.00 | 1900.00 |
| 4 | REF_547892 | 2018 | 4 | AD | Total Loss Payment | PL Retail NS | Retail NS Car | REF_198614 | 2017 | Private Car | REF_915807 | 2018-03-16 15:30:00.0 | 2018-03-16 16:45:26.0 | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq | Closed | Non Fault | Disallowed | Third Party hit Insured | Third Party Hit Insured's Parked Vehicle | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | -1900.00 | 0.00 | -1900.00 | -1900.00 |
| 5 | REF_547892 | 2018 | 5 | AD | Total Loss Payment | PL Retail NS | Retail NS Car | REF_198614 | 2017 | Private Car | REF_915807 | 2018-03-16 15:30:00.0 | 2018-03-16 16:45:26.0 | Joibyfdeqoey zmghor: Womojfxxprbm pzj xdqu lwps tw esok gtcg tjkniok xsq jjhn btp kbttce ptzcri ktw dwkvaudchz. Wuxq kru: Macct rkpcslyq | Closed | Non Fault | Disallowed | Third Party hit Insured | Third Party Hit Insured's Parked Vehicle | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 |
| 6 | REF_715027 | 2018 | 3 | AD | All PH Repair Costs (Exc Fees) | Fleet | SDH | REF_293526 | 2017 | LCV | REF_737241 | 2018-03-10 00:00:00.0 | 2018-03-16 17:36:38.0 | IVT - Uwbof vxfgu sscsjxl tfmwasle mcoa fvzrqpjlqw ztpva lixsd vlnqwws | Closed | Non Fault | Allowed | Insured Hit Third Party | Only Third Party report received to date | 0.00 | 0.0 | 1500.00 | 0.00 | 1500.00 | 1500.00 | 0.00 | 0.0 | 1500.00 | 0.00 | 1500.00 | 1500.00 |
| 7 | REF_715027 | 2018 | 5 | AD | All PH Repair Costs (Exc Fees) | Fleet | SDH | REF_293526 | 2017 | LCV | REF_737241 | 2018-03-10 00:00:00.0 | 2018-03-16 17:36:38.0 | IVT - Uwbof vxfgu sscsjxl tfmwasle mcoa fvzrqpjlqw ztpva lixsd vlnqwws | Closed | Non Fault | Allowed | Insured Hit Third Party | Only Third Party report received to date | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | -1500.00 | 0.00 | -1500.00 | -1500.00 |
| 8 | REF_833081 | 2018 | 4 | AD | All PH Repair Costs (Exc Fees) | PL DA and Affinities | Client Private Car | REF_260480 | 2018 | Private Car | REF_180017 | 2018-03-16 18:45:00.0 | 2018-03-17 12:00:09.0 | FLU - QEVQZ WCM CRGV YOTYSRP. MLMUL CKWTQU KXE EBMI. | Closed | Fault | Disallowed | Insured Hit Non Vehicle | Insured hit animal | 0.00 | 0.0 | 4121.12 | 0.00 | 4121.12 | 4121.12 | 0.00 | 0.0 | 2621.12 | 0.00 | 2621.12 | 2621.12 |
| 9 | REF_903449 | 2018 | 8 | AD | Windscreen Replacement | PL DA and Affinities | Affinities Van | REF_593463 | 2017 | Commercial Vehicle | REF_788894 | 2018-08-06 01:00:00.0 | 2018-08-24 14:20:40.0 | NaN | Closed | Non Fault | Allowed | Windscreen | Windscreen Bordereaux | 106.81 | 0.0 | 0.00 | 106.81 | 0.00 | 106.81 | 106.81 | 0.0 | 0.00 | 106.81 | 0.00 | 106.81 |
| ClaimReferenceNumber | AccidentYear | DevelopmentMonth | HeadofDamage | SubHeadOfDamage | UWClass | UWProduct | PolicyNumber | UnderwritingYear | VehicleType | VehicleReg | EventDate | NotificationDate | ClaimNarrative | ClaimStatus | FaultIndicator | BonusAllowanceDescription | IncidentCause | IncidentSubCause | CumPaid | CumRecovered | CumReserved | CumGrossPaid | CumGrossEstimate | CumGrossIncurred | PaidDelta | RecoveredDelta | ReservedDelta | GrossPaidDelta | GrossEstimateDelta | GrossIncurredDelta | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 163910 | REF_166111 | 2018 | 4 | AD | Miscellaneous Recovery | PL DA and Affinities | Client Private Car | REF_992350 | 2017 | Private Car | REF_116050 | 2018-04-12 09:55:00.0 | 2018-04-12 19:39:43.0 | Our insured was parked up and unattended and a third party had hit the vehicle. Last use was going to the garden centre. | Closed | Non Fault | Allowed | Third Party hit Insured | Third party hit clients unattended vehicle | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 |
| 163911 | REF_321083 | 2018 | 4 | AD | Windscreen Replacement | Commercial | Non Standard Taxi | REF_434260 | 2017 | NaN | REF_269916 | 2018-03-07 00:00:00.0 | 2018-04-13 08:12:27.0 | NQXNKEPGGW5 | Closed | Non Fault | Allowed | Windscreen | Windscreen Replaced | 107.84 | 0.0 | 0.00 | 107.84 | 0.00 | 107.84 | 107.84 | 0.0 | 0.00 | 107.84 | 0.00 | 107.84 |
| 163912 | REF_817111 | 2018 | 15 | AD | Legal Costs - Own | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 310.00 | 0.0 | 0.00 | 310.00 | 0.00 | 310.00 | 187.00 | 0.0 | 0.00 | 187.00 | 0.00 | 187.00 |
| 163913 | REF_817111 | 2018 | 18 | AD | Legal Costs - Own | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 410.00 | 0.0 | 0.00 | 410.00 | 0.00 | 410.00 | 100.00 | 0.0 | 0.00 | 100.00 | 0.00 | 100.00 |
| 163914 | REF_817111 | 2018 | 4 | AD | Miscellaneous Recovery | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 |
| 163915 | REF_817111 | 2018 | 18 | AD | Miscellaneous Recovery | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | 0.00 | 0.00 | 0.00 |
| 163916 | REF_817111 | 2018 | 4 | AD | Policyholder Hire | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 0.00 | 0.0 | 338.94 | 0.00 | 338.94 | 338.94 | 0.00 | 0.0 | 338.94 | 0.00 | 338.94 | 338.94 |
| 163917 | REF_817111 | 2018 | 5 | AD | Policyholder Hire | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 242.16 | 0.0 | 96.78 | 242.16 | 96.78 | 338.94 | 242.16 | 0.0 | -242.16 | 242.16 | -242.16 | 0.00 |
| 163918 | REF_817111 | 2018 | 18 | AD | Policyholder Hire | PL Retail NS | Retail NS Car | REF_560447 | 2017 | Private Car | REF_372421 | 2018-02-05 13:00:00.0 | 2018-04-12 17:57:56.0 | Insured drove over a dipped kerb, one of his tyres drove over the end of one of the stones in the edge of the kerb causing the other end of the kerb stone to lift and hit the fuel protective tank guard and the fuel bracket (however not puncturing a hole, the damage to the fuel tank has caused damage to the vehicle including damaging the fuel sender, the fuel pump has also been damaged, and due to lack of fuel being able to get from the tank to the engine it has damaged the high pressure fuel pump - the high pressure pump has been already paid and sorted under warranty as the manufacturer thought it was a manufacturing warranty issue but the rest of the damage needs sorting | Closed | Non Fault | Disallowed | Third Party hit Insured | Object fell from third party vehicle and hit Insured | 242.16 | 0.0 | 0.00 | 242.16 | 0.00 | 242.16 | 0.00 | 0.0 | -96.78 | 0.00 | -96.78 | -96.78 |
| 163919 | REF_668838 | 2018 | 4 | AD | Windscreen Replacement | PL DA and Affinities | Affinities Car | REF_287887 | 2017 | Private Car | REF_885923 | 2018-02-22 00:00:00.0 | 2018-04-13 08:02:15.0 | YUVCTPDEIL1 | Closed | Non Fault | Allowed | Windscreen | Windscreen Replaced | 107.84 | 0.0 | 0.00 | 107.84 | 0.00 | 107.84 | 107.84 | 0.0 | 0.00 | 107.84 | 0.00 | 107.84 |